Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 1001 |
| Missing cells | 429 |
| Missing cells (%) | 1.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 242.6 KiB |
| Average record size in memory | 248.1 B |
Variable types
| NUM | 17 |
|---|---|
| CAT | 14 |
situs_state has constant value "1001" | Constant |
recording_date has a high cardinality: 201 distinct values | High cardinality |
situs_address has a high cardinality: 962 distinct values | High cardinality |
situs_city has a high cardinality: 124 distinct values | High cardinality |
grantor has a high cardinality: 984 distinct values | High cardinality |
grantee has a high cardinality: 981 distinct values | High cardinality |
lender has a high cardinality: 213 distinct values | High cardinality |
borrower has a high cardinality: 814 distinct values | High cardinality |
grantee_mail_address_raw has a high cardinality: 968 distinct values | High cardinality |
grantee_mail_city has a high cardinality: 148 distinct values | High cardinality |
equity_pct is highly correlated with equity and 1 other fields | High correlation |
equity is highly correlated with equity_pct and 1 other fields | High correlation |
estimated_value_low is highly correlated with estimated_value and 1 other fields | High correlation |
estimated_value is highly correlated with estimated_value_low and 1 other fields | High correlation |
estimated_value_high is highly correlated with estimated_value and 1 other fields | High correlation |
open_loan_amount_1 is highly correlated with equity and 1 other fields | High correlation |
lender has 185 (18.5%) missing values | Missing |
borrower has 185 (18.5%) missing values | Missing |
grantee_mail_address_raw has 12 (1.2%) missing values | Missing |
grantee_mail_city has 12 (1.2%) missing values | Missing |
grantee_mail_state has 12 (1.2%) missing values | Missing |
grantee_mail_zip has 12 (1.2%) missing values | Missing |
equity is highly skewed (γ1 = -22.67721679) | Skewed |
equity_pct is highly skewed (γ1 = -24.22531607) | Skewed |
open_loan_amount_1 is highly skewed (γ1 = 22.67856163) | Skewed |
open_loan_amount_2 is highly skewed (γ1 = 29.08717339) | Skewed |
ratio_sale_avm is highly skewed (γ1 = 22.15535696) | Skewed |
situs_address is uniformly distributed | Uniform |
grantor is uniformly distributed | Uniform |
grantee is uniformly distributed | Uniform |
borrower is uniformly distributed | Uniform |
grantee_mail_address_raw is uniformly distributed | Uniform |
did has unique values | Unique |
census_tract has 455 (45.5%) zeros | Zeros |
open_loan_amount_1 has 139 (13.9%) zeros | Zeros |
open_loan_amount_2 has 747 (74.6%) zeros | Zeros |
open_loan_amount_3 has 962 (96.1%) zeros | Zeros |
ratio_sale_tax has 170 (17.0%) zeros | Zeros |
ratio_sale_avm has 170 (17.0%) zeros | Zeros |
Reproduction
| Analysis started | 2020-11-12 10:05:08.980488 |
|---|---|
| Analysis finished | 2020-11-12 10:07:02.370289 |
| Duration | 1 minute and 53.39 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
pid
Real number (ℝ≥0)
| Distinct | 960 |
|---|---|
| Distinct (%) | 95.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 737009.6693 |
|---|---|
| Minimum | 88916 |
| Maximum | 1405734 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 88916 |
|---|---|
| 5-th percentile | 119584 |
| Q1 | 341173 |
| median | 733652 |
| Q3 | 1150354 |
| 95-th percentile | 1371908 |
| Maximum | 1405734 |
| Range | 1316818 |
| Interquartile range (IQR) | 809181 |
Descriptive statistics
| Standard deviation | 428135.8032 |
|---|---|
| Coefficient of variation (CV) | 0.5809093435 |
| Kurtosis | -1.426989518 |
| Mean | 737009.6693 |
| Median Absolute Deviation (MAD) | 416458 |
| Skewness | 0.007405954676 |
| Sum | 737746679 |
| Variance | 1.833002659e+11 |
| Monotocity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 885549 | 3 | 0.3% | |
| 1191160 | 3 | 0.3% | |
| 1151082 | 2 | 0.2% | |
| 128939 | 2 | 0.2% | |
| 271356 | 2 | 0.2% | |
| 481788 | 2 | 0.2% | |
| 479301 | 2 | 0.2% | |
| 1338378 | 2 | 0.2% | |
| 1216587 | 2 | 0.2% | |
| 565024 | 2 | 0.2% | |
| Other values (950) | 979 | 97.8% |
| Value | Count | Frequency (%) | |
| 88916 | 1 | 0.1% | |
| 88917 | 1 | 0.1% | |
| 91310 | 1 | 0.1% | |
| 91518 | 1 | 0.1% | |
| 91558 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1405734 | 1 | 0.1% | |
| 1405705 | 1 | 0.1% | |
| 1405693 | 1 | 0.1% | |
| 1405684 | 1 | 0.1% | |
| 1405683 | 1 | 0.1% |
| Distinct | 1001 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 671366762.2 |
|---|---|
| Minimum | 660225941 |
| Maximum | 681332938 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 660225941 |
|---|---|
| 5-th percentile | 661454226 |
| Q1 | 666174705 |
| median | 671825774 |
| Q3 | 676474972 |
| 95-th percentile | 680717005 |
| Maximum | 681332938 |
| Range | 21106997 |
| Interquartile range (IQR) | 10300267 |
Descriptive statistics
| Standard deviation | 5993058.503 |
|---|---|
| Coefficient of variation (CV) | 0.008926653567 |
| Kurtosis | -1.153785612 |
| Mean | 671366762.2 |
| Median Absolute Deviation (MAD) | 5165264 |
| Skewness | -0.08632378751 |
| Sum | 6.72038129e+11 |
| Variance | 3.591675022e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 668198911 | 1 | 0.1% | |
| 662125230 | 1 | 0.1% | |
| 668205394 | 1 | 0.1% | |
| 666802887 | 1 | 0.1% | |
| 674695658 | 1 | 0.1% | |
| 668762819 | 1 | 0.1% | |
| 679185090 | 1 | 0.1% | |
| 668367552 | 1 | 0.1% | |
| 679678648 | 1 | 0.1% | |
| 660310711 | 1 | 0.1% | |
| Other values (991) | 991 | 99.0% |
| Value | Count | Frequency (%) | |
| 660225941 | 1 | 0.1% | |
| 660225956 | 1 | 0.1% | |
| 660226598 | 1 | 0.1% | |
| 660226778 | 1 | 0.1% | |
| 660227004 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 681332938 | 1 | 0.1% | |
| 681332917 | 1 | 0.1% | |
| 681265841 | 1 | 0.1% | |
| 681265694 | 1 | 0.1% | |
| 681265067 | 1 | 0.1% |
| Distinct | 201 |
|---|---|
| Distinct (%) | 20.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2020-09-18 | 16 |
|---|---|
| 2020-05-29 | 15 |
| 2020-07-31 | 14 |
| 2020-02-28 | 13 |
| 2020-08-14 | 13 |
| Other values (196) |
| Value | Count | Frequency (%) | |
| 2020-09-18 | 16 | 1.6% | |
| 2020-05-29 | 15 | 1.5% | |
| 2020-07-31 | 14 | 1.4% | |
| 2020-02-28 | 13 | 1.3% | |
| 2020-08-14 | 13 | 1.3% | |
| 2020-06-26 | 12 | 1.2% | |
| 2020-09-04 | 11 | 1.1% | |
| 2020-07-08 | 11 | 1.1% | |
| 2020-07-09 | 11 | 1.1% | |
| 2020-08-07 | 11 | 1.1% | |
| Other values (191) | 874 | 87.3% |
Frequencies of value counts
Unique
| Unique | 17 ? |
|---|---|
| Unique (%) | 1.7% |
Histogram of lengths of the category
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
dt_update
Categorical
| Distinct | 40 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2020-07-23 | |
|---|---|
| 2020-08-27 | |
| 2020-09-24 | |
| 2020-11-05 | |
| 2020-04-09 | |
| Other values (35) |
| Value | Count | Frequency (%) | |
| 2020-07-23 | 204 | 20.4% | |
| 2020-08-27 | 135 | 13.5% | |
| 2020-09-24 | 108 | 10.8% | |
| 2020-11-05 | 54 | 5.4% | |
| 2020-04-09 | 50 | 5.0% | |
| 2020-10-08 | 41 | 4.1% | |
| 2020-08-20 | 39 | 3.9% | |
| 2020-10-01 | 37 | 3.7% | |
| 2020-10-22 | 35 | 3.5% | |
| 2020-03-12 | 32 | 3.2% | |
| Other values (30) | 266 | 26.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
qtr
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2020q3 | |
|---|---|
| 2020q2 | |
| 2020q1 | |
| 2020q4 |
| Value | Count | Frequency (%) | |
| 2020q3 | 417 | 41.7% | |
| 2020q2 | 257 | 25.7% | |
| 2020q1 | 239 | 23.9% | |
| 2020q4 | 88 | 8.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
fips
Real number (ℝ≥0)
| Distinct | 16 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53044.72827 |
|---|---|
| Minimum | 53005 |
| Maximum | 53077 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 53005 |
|---|---|
| 5-th percentile | 53011 |
| Q1 | 53033 |
| median | 53053 |
| Q3 | 53061 |
| 95-th percentile | 53067 |
| Maximum | 53077 |
| Range | 72 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 18.68320342 |
|---|---|
| Coefficient of variation (CV) | 0.0003522160265 |
| Kurtosis | -0.9079509875 |
| Mean | 53044.72827 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.4612784046 |
| Sum | 53097773 |
| Variance | 349.0620899 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 53033 | 246 | 24.6% | |
| 53053 | 186 | 18.6% | |
| 53061 | 143 | 14.3% | |
| 53063 | 122 | 12.2% | |
| 53011 | 101 | 10.1% | |
| 53067 | 50 | 5.0% | |
| 53035 | 38 | 3.8% | |
| 53077 | 21 | 2.1% | |
| 53057 | 19 | 1.9% | |
| 53021 | 19 | 1.9% | |
| Other values (6) | 56 | 5.6% |
| Value | Count | Frequency (%) | |
| 53005 | 13 | 1.3% | |
| 53007 | 1 | 0.1% | |
| 53011 | 101 | 10.1% | |
| 53015 | 16 | 1.6% | |
| 53021 | 19 | 1.9% |
| Value | Count | Frequency (%) | |
| 53077 | 21 | 2.1% | |
| 53073 | 7 | 0.7% | |
| 53067 | 50 | 5.0% | |
| 53063 | 122 | 12.2% | |
| 53061 | 143 | 14.3% |
| Distinct | 962 |
|---|---|
| Distinct (%) | 96.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2319 E Rowan Ave | 3 |
|---|---|
| 2701 H St | 3 |
| 6100 E Evergreen Blvd | 2 |
| 5106 164th St Sw | 2 |
| 433 Commercial Ave | 2 |
| Other values (957) |
| Value | Count | Frequency (%) | |
| 2319 E Rowan Ave | 3 | 0.3% | |
| 2701 H St | 3 | 0.3% | |
| 6100 E Evergreen Blvd | 2 | 0.2% | |
| 5106 164th St Sw | 2 | 0.2% | |
| 433 Commercial Ave | 2 | 0.2% | |
| 2609 34th Ave W | 2 | 0.2% | |
| 2711 Unander Ave | 2 | 0.2% | |
| 3627 Preble St | 2 | 0.2% | |
| 19512 SE 32nd Dr | 2 | 0.2% | |
| 815 26th Ave S | 2 | 0.2% | |
| Other values (952) | 979 | 97.8% |
Frequencies of value counts
Unique
| Unique | 925 ? |
|---|---|
| Unique (%) | 92.4% |
Histogram of lengths of the category
Length
| Max length | 30 |
|---|---|
| Median length | 16 |
| Mean length | 16.41158841 |
| Min length | 9 |
| Distinct | 124 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| Tacoma | |
|---|---|
| Spokane | |
| Seattle | |
| Vancouver | |
| Everett | 31 |
| Other values (119) |
| Value | Count | Frequency (%) | |
| Tacoma | 96 | 9.6% | |
| Spokane | 85 | 8.5% | |
| Seattle | 83 | 8.3% | |
| Vancouver | 75 | 7.5% | |
| Everett | 31 | 3.1% | |
| Puyallup | 27 | 2.7% | |
| Olympia | 26 | 2.6% | |
| Spanaway | 25 | 2.5% | |
| Spokane Valley | 23 | 2.3% | |
| Marysville | 19 | 1.9% | |
| Other values (114) | 511 | 51.0% |
Frequencies of value counts
Unique
| Unique | 33 ? |
|---|---|
| Unique (%) | 3.3% |
Histogram of lengths of the category
Length
| Max length | 17 |
|---|---|
| Median length | 7 |
| Mean length | 7.92007992 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| WA |
|---|
| Value | Count | Frequency (%) | |
| WA | 1001 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
situs_zip
Real number (ℝ≥0)
| Distinct | 217 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98464.32068 |
|---|---|
| Minimum | 98001 |
| Maximum | 99354 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98023 |
| Q1 | 98168 |
| median | 98375 |
| Q3 | 98662 |
| 95-th percentile | 99216 |
| Maximum | 99354 |
| Range | 1353 |
| Interquartile range (IQR) | 494 |
Descriptive statistics
| Standard deviation | 387.6511035 |
|---|---|
| Coefficient of variation (CV) | 0.003936970274 |
| Kurtosis | -0.304739379 |
| Mean | 98464.32068 |
| Median Absolute Deviation (MAD) | 251 |
| Skewness | 0.8763773306 |
| Sum | 98562785 |
| Variance | 150273.3781 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 99207 | 25 | 2.5% | |
| 98387 | 25 | 2.5% | |
| 99205 | 20 | 2.0% | |
| 98404 | 20 | 2.0% | |
| 98409 | 20 | 2.0% | |
| 99301 | 17 | 1.7% | |
| 98444 | 14 | 1.4% | |
| 98026 | 14 | 1.4% | |
| 98198 | 14 | 1.4% | |
| 98201 | 13 | 1.3% | |
| Other values (207) | 819 | 81.8% |
| Value | Count | Frequency (%) | |
| 98001 | 9 | 0.9% | |
| 98002 | 3 | 0.3% | |
| 98003 | 4 | 0.4% | |
| 98004 | 1 | 0.1% | |
| 98006 | 3 | 0.3% |
| Value | Count | Frequency (%) | |
| 99354 | 3 | 0.3% | |
| 99353 | 1 | 0.1% | |
| 99352 | 2 | 0.2% | |
| 99349 | 1 | 0.1% | |
| 99338 | 1 | 0.1% |
| Distinct | 267 |
|---|---|
| Distinct (%) | 26.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25558.64935 |
|---|---|
| Minimum | 0 |
| Maximum | 96110 |
| Zeros | 455 |
| Zeros (%) | 45.5% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1300 |
| Q3 | 53509 |
| 95-th percentile | 90201 |
| Maximum | 96110 |
| Range | 96110 |
| Interquartile range (IQR) | 53509 |
Descriptive statistics
| Standard deviation | 32460.26296 |
|---|---|
| Coefficient of variation (CV) | 1.270030451 |
| Kurtosis | -1.07470747 |
| Mean | 25558.64935 |
| Median Absolute Deviation (MAD) | 1300 |
| Skewness | 0.7451539691 |
| Sum | 25584208 |
| Variance | 1053668672 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 455 | 45.5% | |
| 94000 | 12 | 1.2% | |
| 63300 | 10 | 1.0% | |
| 62900 | 9 | 0.9% | |
| 73114 | 9 | 0.9% | |
| 700 | 8 | 0.8% | |
| 1500 | 8 | 0.8% | |
| 200 | 7 | 0.7% | |
| 73125 | 7 | 0.7% | |
| 70403 | 6 | 0.6% | |
| Other values (257) | 470 | 47.0% |
| Value | Count | Frequency (%) | |
| 0 | 455 | 45.5% | |
| 100 | 1 | 0.1% | |
| 200 | 7 | 0.7% | |
| 300 | 3 | 0.3% | |
| 400 | 2 | 0.2% |
| Value | Count | Frequency (%) | |
| 96110 | 2 | 0.2% | |
| 96090 | 2 | 0.2% | |
| 96080 | 2 | 0.2% | |
| 96040 | 1 | 0.1% | |
| 96030 | 1 | 0.1% |
census_block_group
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| Other values (3) | 38 |
| Value | Count | Frequency (%) | |
| 0 | 455 | 45.5% | |
| 1 | 176 | 17.6% | |
| 2 | 149 | 14.9% | |
| 3 | 127 | 12.7% | |
| 4 | 56 | 5.6% | |
| 5 | 28 | 2.8% | |
| 6 | 9 | 0.9% | |
| 7 | 1 | 0.1% |
Frequencies of value counts
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Histogram of lengths of the category
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 984 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| Bank of America NA | 5 |
|---|---|
| Flyhomes Investments Wa LLC | 3 |
| Dawn M Loftis | 2 |
| Bt Property Investments LLC | 2 |
| Rainier General Dev Inc | 2 |
| Other values (979) |
| Value | Count | Frequency (%) | |
| Bank of America NA | 5 | 0.5% | |
| Flyhomes Investments Wa LLC | 3 | 0.3% | |
| Dawn M Loftis | 2 | 0.2% | |
| Bt Property Investments LLC | 2 | 0.2% | |
| Rainier General Dev Inc | 2 | 0.2% | |
| National Residl Nominee SVCS | 2 | 0.2% | |
| Brandon M Minga | 2 | 0.2% | |
| Dorean Properties LLC | 2 | 0.2% | |
| Cory S Colvin | 2 | 0.2% | |
| Meiwan Zou | 2 | 0.2% | |
| Other values (974) | 977 | 97.6% |
Frequencies of value counts
Unique
| Unique | 971 ? |
|---|---|
| Unique (%) | 97.0% |
Histogram of lengths of the category
Length
| Max length | 52 |
|---|---|
| Median length | 18 |
| Mean length | 19.73326673 |
| Min length | 6 |
| Distinct | 981 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| Ross Road 97 Invs PTRS LLC | 4 |
|---|---|
| Ih6 Property Washington LP | 4 |
| Ginn Group LLC | 3 |
| Flyhomes Investments Wa LLC | 3 |
| Secretary of Hsng & Urban Dev | 2 |
| Other values (976) |
| Value | Count | Frequency (%) | |
| Ross Road 97 Invs PTRS LLC | 4 | 0.4% | |
| Ih6 Property Washington LP | 4 | 0.4% | |
| Ginn Group LLC | 3 | 0.3% | |
| Flyhomes Investments Wa LLC | 3 | 0.3% | |
| Secretary of Hsng & Urban Dev | 2 | 0.2% | |
| Wilmington Trust NA 2015-1 TR | 2 | 0.2% | |
| Bp Family Booth Trust | 2 | 0.2% | |
| Repair Pro Wa LLC | 2 | 0.2% | |
| National Residl Nominee SVCS | 2 | 0.2% | |
| Matthew & Savanna Owens | 2 | 0.2% | |
| Other values (971) | 975 | 97.4% |
Frequencies of value counts
Unique
| Unique | 967 ? |
|---|---|
| Unique (%) | 96.6% |
Histogram of lengths of the category
Length
| Max length | 52 |
|---|---|
| Median length | 23 |
| Mean length | 23.27072927 |
| Min length | 8 |
| Distinct | 213 |
|---|---|
| Distinct (%) | 26.1% |
| Missing | 185 |
| Missing (%) | 18.5% |
| Memory size | 7.8 KiB |
| Fairway Independent MTG | 56 |
|---|---|
| Caliber Hm Loans | 54 |
| Guild MTG | 30 |
| Evergreen Moneysource MTG | 29 |
| Homebridge Fin'l SVCS Inc | 20 |
| Other values (208) |
| Value | Count | Frequency (%) | |
| Fairway Independent MTG | 56 | 5.6% | |
| Caliber Hm Loans | 54 | 5.4% | |
| Guild MTG | 30 | 3.0% | |
| Evergreen Moneysource MTG | 29 | 2.9% | |
| Homebridge Fin'l SVCS Inc | 20 | 2.0% | |
| Umpqua BK | 19 | 1.9% | |
| Movement MTG | 18 | 1.8% | |
| Fairway Independent Mtg | 17 | 1.7% | |
| Crosscountry MTG | 17 | 1.7% | |
| Wells Fargo BK | 15 | 1.5% | |
| Other values (203) | 541 | 54.0% | |
| (Missing) | 185 | 18.5% |
Frequencies of value counts
Unique
| Unique | 118 ? |
|---|---|
| Unique (%) | 14.5% |
Histogram of lengths of the category
Length
| Max length | 38 |
|---|---|
| Median length | 14 |
| Mean length | 13.48651349 |
| Min length | 3 |
| Distinct | 814 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 185 |
| Missing (%) | 18.5% |
| Memory size | 7.8 KiB |
| Matthew & Savanna Owens | 2 |
|---|---|
| Twin Estates LLC | 2 |
| Ariel Garcia | Calvin Jr Lindsay | 1 |
| Christine L Razee | 1 |
| Raymond L & Nicole L Guerrero | 1 |
| Other values (809) |
| Value | Count | Frequency (%) | |
| Matthew & Savanna Owens | 2 | 0.2% | |
| Twin Estates LLC | 2 | 0.2% | |
| Ariel Garcia | Calvin Jr Lindsay | 1 | 0.1% | |
| Christine L Razee | 1 | 0.1% | |
| Raymond L & Nicole L Guerrero | 1 | 0.1% | |
| Brian & Erlinda A Tuskan | 1 | 0.1% | |
| Genolinsky M & Rowena R Lopez | 1 | 0.1% | |
| Van V & Joe Cao | Weijun Ouyang | 1 | 0.1% | |
| Travis Betts | 1 | 0.1% | |
| William A & Nicole L Frank | 1 | 0.1% | |
| Other values (804) | 804 | 80.3% | |
| (Missing) | 185 | 18.5% |
Frequencies of value counts
Unique
| Unique | 812 ? |
|---|---|
| Unique (%) | 99.5% |
Histogram of lengths of the category
Length
| Max length | 52 |
|---|---|
| Median length | 21 |
| Mean length | 19.93206793 |
| Min length | 3 |
| Distinct | 968 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 12 |
| Missing (%) | 1.2% |
| Memory size | 7.8 KiB |
| 1717 MAIN ST #2000 DALLAS TX 752014657 | 4 |
|---|---|
| 400 N 34TH ST #300 SEATTLE WA 981038600 | 4 |
| 1201 WESTERN AVE #100 SEATTLE WA 981012953 | 3 |
| 7223 NE HAZEL DELL AVE VANCOUVER WA 986658326 | 3 |
| 32127 E MORRISON ST CARNATION WA 980145057 | 2 |
| Other values (963) |
| Value | Count | Frequency (%) | |
| 1717 MAIN ST #2000 DALLAS TX 752014657 | 4 | 0.4% | |
| 400 N 34TH ST #300 SEATTLE WA 981038600 | 4 | 0.4% | |
| 1201 WESTERN AVE #100 SEATTLE WA 981012953 | 3 | 0.3% | |
| 7223 NE HAZEL DELL AVE VANCOUVER WA 986658326 | 3 | 0.3% | |
| 32127 E MORRISON ST CARNATION WA 980145057 | 2 | 0.2% | |
| 706 W GARLAND AVE SPOKANE WA 992052959 | 2 | 0.2% | |
| 201 N 30TH ST MOUNT VERNON WA 982733671 | 2 | 0.2% | |
| 5324 BELLAIRE AVE VALLEY VILLAGE CA 916072330 | 2 | 0.2% | |
| 11632 74TH AVE S SEATTLE WA 981783009 | 2 | 0.2% | |
| 19512 SE 32ND DR CAMAS WA 986079447 | 2 | 0.2% | |
| Other values (958) | 963 | 96.2% | |
| (Missing) | 12 | 1.2% |
Frequencies of value counts
Unique
| Unique | 953 ? |
|---|---|
| Unique (%) | 96.4% |
Histogram of lengths of the category
Length
| Max length | 57 |
|---|---|
| Median length | 38 |
| Mean length | 38.0969031 |
| Min length | 3 |
| Distinct | 148 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 12 |
| Missing (%) | 1.2% |
| Memory size | 7.8 KiB |
| SEATTLE | |
|---|---|
| TACOMA | |
| SPOKANE | |
| VANCOUVER | |
| EVERETT | 29 |
| Other values (143) |
| Value | Count | Frequency (%) | |
| SEATTLE | 95 | 9.5% | |
| TACOMA | 82 | 8.2% | |
| SPOKANE | 76 | 7.6% | |
| VANCOUVER | 68 | 6.8% | |
| EVERETT | 29 | 2.9% | |
| PUYALLUP | 26 | 2.6% | |
| OLYMPIA | 25 | 2.5% | |
| SPANAWAY | 22 | 2.2% | |
| SPOKANE VALLEY | 21 | 2.1% | |
| PASCO | 17 | 1.7% | |
| Other values (138) | 528 | 52.7% |
Frequencies of value counts
Unique
| Unique | 53 ? |
|---|---|
| Unique (%) | 5.4% |
Histogram of lengths of the category
Length
| Max length | 17 |
|---|---|
| Median length | 7 |
| Mean length | 7.946053946 |
| Min length | 3 |
| Distinct | 14 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 12 |
| Missing (%) | 1.2% |
| Memory size | 7.8 KiB |
| WA | |
|---|---|
| CA | 8 |
| TX | 6 |
| AZ | 3 |
| OR | 3 |
| Other values (9) | 11 |
| Value | Count | Frequency (%) | |
| WA | 958 | 95.7% | |
| CA | 8 | 0.8% | |
| TX | 6 | 0.6% | |
| AZ | 3 | 0.3% | |
| OR | 3 | 0.3% | |
| FL | 2 | 0.2% | |
| ID | 2 | 0.2% | |
| KS | 1 | 0.1% | |
| OK | 1 | 0.1% | |
| MA | 1 | 0.1% | |
| Other values (4) | 4 | 0.4% | |
| (Missing) | 12 | 1.2% |
Frequencies of value counts
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.7% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.011988012 |
| Min length | 2 |
| Distinct | 250 |
|---|---|
| Distinct (%) | 25.3% |
| Missing | 12 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 97784.77958 |
|---|---|
| Minimum | 1089 |
| Maximum | 99354 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 1089 |
|---|---|
| 5-th percentile | 98006 |
| Q1 | 98109 |
| median | 98370 |
| Q3 | 98632 |
| 95-th percentile | 99212 |
| Maximum | 99354 |
| Range | 98265 |
| Interquartile range (IQR) | 523 |
Descriptive statistics
| Standard deviation | 5683.751917 |
|---|---|
| Coefficient of variation (CV) | 0.05812511867 |
| Kurtosis | 176.6087417 |
| Mean | 97784.77958 |
| Median Absolute Deviation (MAD) | 262 |
| Skewness | -12.38259215 |
| Sum | 96709147 |
| Variance | 32305035.86 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 98387 | 22 | 2.2% | |
| 99207 | 21 | 2.1% | |
| 99205 | 19 | 1.9% | |
| 99301 | 17 | 1.7% | |
| 98409 | 17 | 1.7% | |
| 98404 | 14 | 1.4% | |
| 98374 | 12 | 1.2% | |
| 98106 | 12 | 1.2% | |
| 98026 | 12 | 1.2% | |
| 98258 | 12 | 1.2% | |
| Other values (240) | 831 | 83.0% |
| Value | Count | Frequency (%) | |
| 1089 | 1 | 0.1% | |
| 10019 | 1 | 0.1% | |
| 32256 | 1 | 0.1% | |
| 34689 | 1 | 0.1% | |
| 67058 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 99354 | 3 | 0.3% | |
| 99353 | 1 | 0.1% | |
| 99352 | 2 | 0.2% | |
| 99350 | 1 | 0.1% | |
| 99338 | 1 | 0.1% |
| Distinct | 862 |
|---|---|
| Distinct (%) | 86.2% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -2177929.927 |
|---|---|
| Minimum | -1300077000 |
| Maximum | 2215000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | -1300077000 |
|---|---|
| 5-th percentile | 16050 |
| Q1 | 86959.75 |
| median | 144370 |
| Q3 | 245420.5 |
| 95-th percentile | 515170 |
| Maximum | 2215000 |
| Range | 1302292000 |
| Interquartile range (IQR) | 158460.75 |
Descriptive statistics
| Standard deviation | 52965185.67 |
|---|---|
| Coefficient of variation (CV) | -24.31904949 |
| Kurtosis | 518.4077116 |
| Mean | -2177929.927 |
| Median Absolute Deviation (MAD) | 72355 |
| Skewness | -22.67721679 |
| Sum | -2177929927 |
| Variance | 2.805310893e+15 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 109000 | 5 | 0.5% | |
| 211000 | 4 | 0.4% | |
| 267000 | 4 | 0.4% | |
| 187000 | 4 | 0.4% | |
| 162000 | 4 | 0.4% | |
| 135000 | 4 | 0.4% | |
| 55000 | 3 | 0.3% | |
| 462000 | 3 | 0.3% | |
| 236000 | 3 | 0.3% | |
| 237000 | 3 | 0.3% | |
| Other values (852) | 963 | 96.2% |
| Value | Count | Frequency (%) | |
| -1300077000 | 1 | 0.1% | |
| -1056810000 | 1 | 0.1% | |
| -10397000 | 1 | 0.1% | |
| -2544000 | 1 | 0.1% | |
| -1868599 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2215000 | 1 | 0.1% | |
| 1888000 | 1 | 0.1% | |
| 1680432 | 1 | 0.1% | |
| 1479000 | 1 | 0.1% | |
| 1336000 | 1 | 0.1% |
| Distinct | 874 |
|---|---|
| Distinct (%) | 87.4% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.385185376 |
|---|---|
| Minimum | -4248.62 |
| Maximum | 1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | -4248.62 |
|---|---|
| 5-th percentile | 0.04777772 |
| Q1 | 0.27598 |
| median | 0.4018405 |
| Q3 | 0.575424 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 4249.62 |
| Interquartile range (IQR) | 0.299444 |
Descriptive statistics
| Standard deviation | 156.5884261 |
|---|---|
| Coefficient of variation (CV) | -24.5237087 |
| Kurtosis | 609.2031152 |
| Mean | -6.385185376 |
| Median Absolute Deviation (MAD) | 0.143695 |
| Skewness | -24.22531607 |
| Sum | -6385.185376 |
| Variance | 24519.9352 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1 | 114 | 11.4% | |
| 0.251773 | 2 | 0.2% | |
| 0.35743 | 2 | 0.2% | |
| 0.27598 | 2 | 0.2% | |
| 0.41896 | 2 | 0.2% | |
| 0.494915 | 2 | 0.2% | |
| 0.792961 | 2 | 0.2% | |
| 0.333333 | 2 | 0.2% | |
| 0.106141 | 2 | 0.2% | |
| 0.554622 | 2 | 0.2% | |
| Other values (864) | 868 | 86.7% |
| Value | Count | Frequency (%) | |
| -4248.62 | 1 | 0.1% | |
| -2546.53 | 1 | 0.1% | |
| -15.6817 | 1 | 0.1% | |
| -7.14607 | 1 | 0.1% | |
| -4.08884 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 114 | 11.4% | |
| 0.995579 | 1 | 0.1% | |
| 0.990147 | 1 | 0.1% | |
| 0.955407 | 1 | 0.1% | |
| 0.952319 | 1 | 0.1% |
| Distinct | 505 |
|---|---|
| Distinct (%) | 50.5% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 433215 |
|---|---|
| Minimum | 103000 |
| Maximum | 2928000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 103000 |
|---|---|
| 5-th percentile | 181000 |
| Q1 | 282000 |
| median | 360000 |
| Q3 | 500000 |
| 95-th percentile | 864400 |
| Maximum | 2928000 |
| Range | 2825000 |
| Interquartile range (IQR) | 218000 |
Descriptive statistics
| Standard deviation | 270037.1397 |
|---|---|
| Coefficient of variation (CV) | 0.623332848 |
| Kurtosis | 20.14808685 |
| Mean | 433215 |
| Median Absolute Deviation (MAD) | 99000 |
| Skewness | 3.506902995 |
| Sum | 433215000 |
| Variance | 7.292005683e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 316000 | 8 | 0.8% | |
| 296000 | 8 | 0.8% | |
| 313000 | 8 | 0.8% | |
| 259000 | 7 | 0.7% | |
| 320000 | 7 | 0.7% | |
| 354000 | 7 | 0.7% | |
| 347000 | 7 | 0.7% | |
| 326000 | 7 | 0.7% | |
| 282000 | 6 | 0.6% | |
| 281000 | 6 | 0.6% | |
| Other values (495) | 929 | 92.8% |
| Value | Count | Frequency (%) | |
| 103000 | 2 | 0.2% | |
| 113000 | 1 | 0.1% | |
| 114000 | 1 | 0.1% | |
| 116000 | 1 | 0.1% | |
| 124000 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2928000 | 1 | 0.1% | |
| 2705000 | 1 | 0.1% | |
| 2229000 | 1 | 0.1% | |
| 2152000 | 1 | 0.1% | |
| 2015000 | 1 | 0.1% |
| Distinct | 479 |
|---|---|
| Distinct (%) | 47.9% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 358481 |
|---|---|
| Minimum | 74000 |
| Maximum | 2238000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 74000 |
|---|---|
| 5-th percentile | 137000 |
| Q1 | 232000 |
| median | 307000 |
| Q3 | 421000 |
| 95-th percentile | 700050 |
| Maximum | 2238000 |
| Range | 2164000 |
| Interquartile range (IQR) | 189000 |
Descriptive statistics
| Standard deviation | 217016.8518 |
|---|---|
| Coefficient of variation (CV) | 0.6053789511 |
| Kurtosis | 16.46734417 |
| Mean | 358481 |
| Median Absolute Deviation (MAD) | 88000 |
| Skewness | 3.087761106 |
| Sum | 358481000 |
| Variance | 4.709631395e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 284000 | 8 | 0.8% | |
| 213000 | 8 | 0.8% | |
| 290000 | 7 | 0.7% | |
| 294000 | 7 | 0.7% | |
| 301000 | 7 | 0.7% | |
| 277000 | 7 | 0.7% | |
| 275000 | 7 | 0.7% | |
| 298000 | 7 | 0.7% | |
| 240000 | 7 | 0.7% | |
| 352000 | 6 | 0.6% | |
| Other values (469) | 929 | 92.8% |
| Value | Count | Frequency (%) | |
| 74000 | 1 | 0.1% | |
| 77000 | 1 | 0.1% | |
| 80000 | 1 | 0.1% | |
| 82000 | 1 | 0.1% | |
| 87000 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2238000 | 1 | 0.1% | |
| 2201000 | 1 | 0.1% | |
| 1636000 | 1 | 0.1% | |
| 1585000 | 1 | 0.1% | |
| 1577000 | 1 | 0.1% |
| Distinct | 546 |
|---|---|
| Distinct (%) | 54.6% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 507951 |
|---|---|
| Minimum | 126000 |
| Maximum | 3655000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 126000 |
|---|---|
| 5-th percentile | 222000 |
| Q1 | 330000 |
| median | 414500 |
| Q3 | 581000 |
| 95-th percentile | 1028950 |
| Maximum | 3655000 |
| Range | 3529000 |
| Interquartile range (IQR) | 251000 |
Descriptive statistics
| Standard deviation | 325733.0481 |
|---|---|
| Coefficient of variation (CV) | 0.6412686422 |
| Kurtosis | 22.93952167 |
| Mean | 507951 |
| Median Absolute Deviation (MAD) | 109500 |
| Skewness | 3.790656648 |
| Sum | 507951000 |
| Variance | 1.061020186e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 448000 | 9 | 0.9% | |
| 323000 | 8 | 0.8% | |
| 472000 | 6 | 0.6% | |
| 346000 | 6 | 0.6% | |
| 389000 | 6 | 0.6% | |
| 386000 | 6 | 0.6% | |
| 297000 | 6 | 0.6% | |
| 573000 | 5 | 0.5% | |
| 413000 | 5 | 0.5% | |
| 371000 | 5 | 0.5% | |
| Other values (536) | 938 | 93.7% |
| Value | Count | Frequency (%) | |
| 126000 | 1 | 0.1% | |
| 132000 | 1 | 0.1% | |
| 145000 | 1 | 0.1% | |
| 146000 | 1 | 0.1% | |
| 150000 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 3655000 | 1 | 0.1% | |
| 3172000 | 1 | 0.1% | |
| 2930000 | 1 | 0.1% | |
| 2719000 | 1 | 0.1% | |
| 2394000 | 1 | 0.1% |
| Distinct | 729 |
|---|---|
| Distinct (%) | 72.9% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2572099.939 |
|---|---|
| Minimum | 0 |
| Maximum | 1300383000 |
| Zeros | 139 |
| Zeros (%) | 13.9% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 116982.75 |
| median | 194860 |
| Q3 | 284357.5 |
| 95-th percentile | 495000 |
| Maximum | 1300383000 |
| Range | 1300383000 |
| Interquartile range (IQR) | 167374.75 |
Descriptive statistics
| Standard deviation | 52962161.32 |
|---|---|
| Coefficient of variation (CV) | 20.59102001 |
| Kurtosis | 518.4406483 |
| Mean | 2572099.939 |
| Median Absolute Deviation (MAD) | 83710 |
| Skewness | 22.67856163 |
| Sum | 2572099939 |
| Variance | 2.804990531e+15 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 139 | 13.9% | |
| 417000 | 8 | 0.8% | |
| 190000 | 5 | 0.5% | |
| 160000 | 5 | 0.5% | |
| 150000 | 5 | 0.5% | |
| 285000 | 5 | 0.5% | |
| 288000 | 5 | 0.5% | |
| 144000 | 4 | 0.4% | |
| 180000 | 4 | 0.4% | |
| 164000 | 4 | 0.4% | |
| Other values (719) | 816 | 81.5% |
| Value | Count | Frequency (%) | |
| 0 | 139 | 13.9% | |
| 20000 | 1 | 0.1% | |
| 22575 | 1 | 0.1% | |
| 34500 | 1 | 0.1% | |
| 36500 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1300383000 | 1 | 0.1% | |
| 1057225000 | 1 | 0.1% | |
| 2325599 | 1 | 0.1% | |
| 1650000 | 1 | 0.1% | |
| 1610000 | 1 | 0.1% |
| Distinct | 179 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35196.167 |
|---|---|
| Minimum | 0 |
| Maximum | 11060000 |
| Zeros | 747 |
| Zeros (%) | 74.6% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1795.25 |
| 95-th percentile | 137880.85 |
| Maximum | 11060000 |
| Range | 11060000 |
| Interquartile range (IQR) | 1795.25 |
Descriptive statistics
| Standard deviation | 359388.9477 |
|---|---|
| Coefficient of variation (CV) | 10.21102519 |
| Kurtosis | 889.3066603 |
| Mean | 35196.167 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 29.08717339 |
| Sum | 35196167 |
| Variance | 1.291604157e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 747 | 74.6% | |
| 50000 | 17 | 1.7% | |
| 100000 | 15 | 1.5% | |
| 25000 | 6 | 0.6% | |
| 20000 | 6 | 0.6% | |
| 75000 | 5 | 0.5% | |
| 200000 | 4 | 0.4% | |
| 35000 | 3 | 0.3% | |
| 10000 | 3 | 0.3% | |
| 110000 | 3 | 0.3% | |
| Other values (169) | 191 | 19.1% |
| Value | Count | Frequency (%) | |
| 0 | 747 | 74.6% | |
| 1 | 2 | 0.2% | |
| 1543 | 1 | 0.1% | |
| 2552 | 1 | 0.1% | |
| 3300 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 11060000 | 1 | 0.1% | |
| 1700000 | 1 | 0.1% | |
| 835000 | 1 | 0.1% | |
| 728000 | 1 | 0.1% | |
| 500000 | 1 | 0.1% |
| Distinct | 39 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3848.821 |
|---|---|
| Minimum | 0 |
| Maximum | 375000 |
| Zeros | 962 |
| Zeros (%) | 96.1% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 375000 |
| Range | 375000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 26767.77557 |
|---|---|
| Coefficient of variation (CV) | 6.954798773 |
| Kurtosis | 101.9618684 |
| Mean | 3848.821 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.398289706 |
| Sum | 3848821 |
| Variance | 716513808.9 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=39)
| Value | Count | Frequency (%) | |
| 0 | 962 | 96.1% | |
| 100000 | 1 | 0.1% | |
| 8326 | 1 | 0.1% | |
| 64150 | 1 | 0.1% | |
| 158800 | 1 | 0.1% | |
| 65700 | 1 | 0.1% | |
| 50001 | 1 | 0.1% | |
| 20000 | 1 | 0.1% | |
| 50000 | 1 | 0.1% | |
| 89500 | 1 | 0.1% | |
| Other values (29) | 29 | 2.9% |
| Value | Count | Frequency (%) | |
| 0 | 962 | 96.1% | |
| 7433 | 1 | 0.1% | |
| 8128 | 1 | 0.1% | |
| 8326 | 1 | 0.1% | |
| 9083 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 375000 | 1 | 0.1% | |
| 370000 | 1 | 0.1% | |
| 250600 | 1 | 0.1% | |
| 250000 | 1 | 0.1% | |
| 240000 | 1 | 0.1% |
| Distinct | 814 |
|---|---|
| Distinct (%) | 81.4% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.171191565 |
|---|---|
| Minimum | 0 |
| Maximum | 37.628 |
| Zeros | 170 |
| Zeros (%) | 17.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.966265 |
| median | 1.25177 |
| Q3 | 1.40812 |
| 95-th percentile | 1.8300555 |
| Maximum | 37.628 |
| Range | 37.628 |
| Interquartile range (IQR) | 0.441855 |
Descriptive statistics
| Standard deviation | 1.521617291 |
|---|---|
| Coefficient of variation (CV) | 1.299204448 |
| Kurtosis | 360.3089051 |
| Mean | 1.171191565 |
| Median Absolute Deviation (MAD) | 0.198555 |
| Skewness | 16.58444876 |
| Sum | 1171.191565 |
| Variance | 2.315319179 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 170 | 17.0% | |
| 1.39466 | 2 | 0.2% | |
| 1.38889 | 2 | 0.2% | |
| 1.10755 | 2 | 0.2% | |
| 1.19048 | 2 | 0.2% | |
| 1.00402 | 2 | 0.2% | |
| 1.28529 | 2 | 0.2% | |
| 1.33581 | 2 | 0.2% | |
| 1.11558 | 2 | 0.2% | |
| 1.38494 | 2 | 0.2% | |
| Other values (804) | 812 | 81.1% |
| Value | Count | Frequency (%) | |
| 0 | 170 | 17.0% | |
| 0.0130339 | 1 | 0.1% | |
| 0.0195448 | 1 | 0.1% | |
| 0.0213707 | 1 | 0.1% | |
| 0.0221771 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 37.628 | 1 | 0.1% | |
| 18.5977 | 1 | 0.1% | |
| 17.6503 | 1 | 0.1% | |
| 5.98826 | 1 | 0.1% | |
| 5.90967 | 1 | 0.1% |
| Distinct | 779 |
|---|---|
| Distinct (%) | 77.9% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8677135854 |
|---|---|
| Minimum | 0 |
| Maximum | 29.9095 |
| Zeros | 170 |
| Zeros (%) | 17.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.7456355 |
| median | 0.994285 |
| Q3 | 1.07325 |
| 95-th percentile | 1.301014 |
| Maximum | 29.9095 |
| Range | 29.9095 |
| Interquartile range (IQR) | 0.3276145 |
Descriptive statistics
| Standard deviation | 1.035829208 |
|---|---|
| Coefficient of variation (CV) | 1.193745523 |
| Kurtosis | 619.8855017 |
| Mean | 0.8677135854 |
| Median Absolute Deviation (MAD) | 0.111135 |
| Skewness | 22.15535696 |
| Sum | 867.7135854 |
| Variance | 1.072942147 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 170 | 17.0% | |
| 1 | 10 | 1.0% | |
| 1.03448 | 4 | 0.4% | |
| 1.02041 | 4 | 0.4% | |
| 1.02941 | 3 | 0.3% | |
| 1.11111 | 3 | 0.3% | |
| 1.05 | 2 | 0.2% | |
| 1.025 | 2 | 0.2% | |
| 0.905172 | 2 | 0.2% | |
| 1.03306 | 2 | 0.2% | |
| Other values (769) | 798 | 79.7% |
| Value | Count | Frequency (%) | |
| 0 | 170 | 17.0% | |
| 0.0102533 | 1 | 0.1% | |
| 0.0149112 | 1 | 0.1% | |
| 0.0152285 | 1 | 0.1% | |
| 0.0163912 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 29.9095 | 1 | 0.1% | |
| 4.90682 | 1 | 0.1% | |
| 4.85349 | 1 | 0.1% | |
| 3.46386 | 1 | 0.1% | |
| 3.18309 | 1 | 0.1% |
square_footage
Real number (ℝ≥0)
| Distinct | 628 |
|---|---|
| Distinct (%) | 62.8% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1588.479 |
|---|---|
| Minimum | 504 |
| Maximum | 13787 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 504 |
|---|---|
| 5-th percentile | 803.8 |
| Q1 | 1121.75 |
| median | 1391 |
| Q3 | 1840 |
| 95-th percentile | 2849.75 |
| Maximum | 13787 |
| Range | 13283 |
| Interquartile range (IQR) | 718.25 |
Descriptive statistics
| Standard deviation | 873.0548404 |
|---|---|
| Coefficient of variation (CV) | 0.5496168601 |
| Kurtosis | 76.93192069 |
| Mean | 1588.479 |
| Median Absolute Deviation (MAD) | 339.5 |
| Skewness | 6.328318678 |
| Sum | 1588479 |
| Variance | 762224.7543 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1140 | 10 | 1.0% | |
| 1160 | 9 | 0.9% | |
| 960 | 7 | 0.7% | |
| 1520 | 6 | 0.6% | |
| 768 | 6 | 0.6% | |
| 840 | 6 | 0.6% | |
| 1200 | 6 | 0.6% | |
| 1240 | 6 | 0.6% | |
| 1280 | 6 | 0.6% | |
| 1260 | 6 | 0.6% | |
| Other values (618) | 932 | 93.1% |
| Value | Count | Frequency (%) | |
| 504 | 1 | 0.1% | |
| 540 | 2 | 0.2% | |
| 576 | 1 | 0.1% | |
| 590 | 1 | 0.1% | |
| 598 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 13787 | 2 | 0.2% | |
| 5550 | 1 | 0.1% | |
| 5480 | 1 | 0.1% | |
| 5464 | 1 | 0.1% | |
| 5140 | 1 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
First rows
| pid | did | recording_date | dt_update | qtr | fips | situs_address | situs_city | situs_state | situs_zip | census_tract | census_block_group | grantor | grantee | lender | borrower | grantee_mail_address_raw | grantee_mail_city | grantee_mail_state | grantee_mail_zip | equity | equity_pct | estimated_value | estimated_value_low | estimated_value_high | open_loan_amount_1 | open_loan_amount_2 | open_loan_amount_3 | ratio_sale_tax | ratio_sale_avm | square_footage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 88916 | 668849143 | 2020-05-26 | 2020-07-23 | 2020q2 | 53063 | 421 S Custer Rd | Spokane Valley | WA | 99212 | 12300 | 4 | Tyler & Saralynn Dilg | Guy Henne | Erica A Whitmarsh | Guild MTG | Guy Henne | Erica A Whitmarsh | 421 S CUSTER RD SPOKANE VALLEY WA 992120324 | SPOKANE VALLEY | WA | 99212.0 | 113000.0 | 0.551220 | 205000.0 | 158000.0 | 253000.0 | 92000.0 | 0.0 | 0.0 | 1.61025 | 1.09756 | 1898.0 |
| 1 | 88917 | 671200400 | 2020-06-23 | 2020-07-23 | 2020q2 | 53063 | 11109 E Springfield Ave | Spokane Valley | WA | 99206 | 11900 | 2 | Lana Leneriz | Joshua L & Shannan G Pyle | LOANDEPOT.COM LLC | Joshua L & Shannan G Pyle | 11109 E SPRINGFIELD AVE SPOKANE VALLEY WA 992066225 | SPOKANE VALLEY | WA | 99206.0 | 145250.0 | 0.600207 | 242000.0 | 199000.0 | 285000.0 | 96750.0 | 0.0 | 0.0 | 1.95877 | 1.38409 | 1233.0 |
| 2 | 91310 | 666661920 | 2020-04-27 | 2020-05-14 | 2020q2 | 53033 | 6828 S 116th Pl | Seattle | WA | 98178 | 0 | 0 | Adisu Fanta | Hugo Velazquez | Krystal Bautista | Quicken Lns | Hugo Velazquez | Krystal Bautista | 6828 S 116TH PL TUKWILA WA 981783025 | TUKWILA | WA | 98178.0 | 159000.0 | 0.362187 | 439000.0 | 376000.0 | 502000.0 | 280000.0 | 0.0 | 0.0 | 1.29526 | 1.05923 | 1450.0 |
| 3 | 91518 | 668220264 | 2020-05-26 | 2020-06-11 | 2020q2 | 53011 | 21811 NE 28th St | Camas | WA | 98607 | 0 | 0 | Scott J Currie | Marc & Valerie V Mouser | Penrith Hm Lns | Marc & Valerie V Mouser | 21811 NE 28TH ST CAMAS WA 986079298 | CAMAS | WA | 98607.0 | 71680.0 | 0.188136 | 381000.0 | 307000.0 | 455000.0 | 309320.0 | 0.0 | 0.0 | 0.00000 | 0.00000 | 1156.0 |
| 4 | 91558 | 678052767 | 2020-09-14 | 2020-10-01 | 2020q3 | 53061 | 19926 York Rd | Bothell | WA | 98012 | 51924 | 2 | David L & Victoria McNeely | Snohomish County | NaN | NaN | 3000 ROCKEFELLER AVE EVERETT WA 982014071 | EVERETT | WA | 98201.0 | 251500.0 | 0.528361 | 476000.0 | 399000.0 | 553000.0 | 224500.0 | 0.0 | 0.0 | 0.00000 | 0.00000 | 1236.0 |
| 5 | 93018 | 662576287 | 2020-02-05 | 2020-08-27 | 2020q1 | 53021 | 519 S Douglas Ave | Pasco | WA | 99301 | 0 | 0 | Joseph B Zilar | Dustin P Nelson | Yessenia Mendoza | Homebridge Fin'l SVCS Inc | Dustin P Nelson | Yessenia Mendoza | 519 S DOUGLAS AVE PASCO WA 993014412 | PASCO | WA | 99301.0 | 103393.0 | 0.469968 | 220000.0 | 179000.0 | 260000.0 | 116607.0 | 0.0 | 0.0 | 1.88134 | 1.04500 | 1116.0 |
| 6 | 93453 | 680717693 | 2020-10-13 | 2020-11-05 | 2020q4 | 53067 | 16266 Old Highway 99 Se | Tenino | WA | 98589 | 0 | 0 | Rainier General Dev Inc | John Robinson | NaN | NaN | 320 BRIAR LN S TENINO WA 98589 | TENINO | WA | 98589.0 | 319000.0 | 1.000000 | 319000.0 | 240000.0 | 399000.0 | 0.0 | 0.0 | 0.0 | 0.00000 | 0.00000 | 13787.0 |
| 7 | 93453 | 681332938 | 2020-10-20 | 2020-11-05 | 2020q4 | 53067 | 16266 Old Highway 99 Se | Tenino | WA | 98589 | 0 | 0 | Rainier General Dev Inc | William A & Nicole L Frank | Caliber Hm Loans | William A & Nicole L Frank | 381 BRIAR LN S TENINO WA 98589 | TENINO | WA | 98589.0 | 319000.0 | 1.000000 | 319000.0 | 240000.0 | 399000.0 | 0.0 | 0.0 | 0.0 | 0.00000 | 0.00000 | 13787.0 |
| 8 | 93932 | 681039619 | 2020-10-20 | 2020-11-05 | 2020q4 | 53035 | 26039 Leyman Ln Ne | Kingston | WA | 98346 | 90102 | 1 | Harvey Wolff | Elray & Sharon Konkel | Washington Fed'l BK | Elray & Sharon Konkel | 26039 LEYMAN LN NE KINGSTON WA 983469421 | KINGSTON | WA | 98346.0 | 912000.0 | 1.000000 | 912000.0 | 704000.0 | 1120000.0 | 0.0 | 0.0 | 0.0 | 0.00000 | 0.00000 | 3654.0 |
| 9 | 93952 | 679679406 | 2020-10-02 | 2020-10-22 | 2020q4 | 53053 | 4825 S D St | Tacoma | WA | 98408 | 62400 | 4 | Stephen P Cox | Angelic Properties LLC | Eastside FNDG | Angelic Properties LLC | 4825 S D ST TACOMA WA 984086511 | TACOMA | WA | 98408.0 | 179000.0 | 0.566456 | 316000.0 | 245000.0 | 386000.0 | 109600.0 | 27400.0 | 0.0 | 0.00000 | 0.00000 | 1163.0 |
Last rows
| pid | did | recording_date | dt_update | qtr | fips | situs_address | situs_city | situs_state | situs_zip | census_tract | census_block_group | grantor | grantee | lender | borrower | grantee_mail_address_raw | grantee_mail_city | grantee_mail_state | grantee_mail_zip | equity | equity_pct | estimated_value | estimated_value_low | estimated_value_high | open_loan_amount_1 | open_loan_amount_2 | open_loan_amount_3 | ratio_sale_tax | ratio_sale_avm | square_footage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 991 | 1405613 | 678009573 | 2020-09-09 | 2020-10-01 | 2020q3 | 53053 | 9311 62nd Ave E | Puyallup | WA | 98371 | 71205 | 2 | Erica R Branche | Jose A G Soto | Daisy G Gomez | Fairway Independent MTG | Jose A G Soto | Daisy G Gomez | 9311 62ND AVE E PUYALLUP WA 983716251 | PUYALLUP | WA | 98371.0 | 125400.0 | 0.303632 | 413000.0 | 361000.0 | 465000.0 | 287600.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 1645.0 |
| 992 | 1405626 | 672768056 | 2020-07-16 | 2020-08-27 | 2020q3 | 53053 | 8802 63rd Ave E | Puyallup | WA | 98371 | 71205 | 2 | Carrie M Rutt | Austin G Andal | Paramount Resid'l MTG | Austin G Andal | 8802 63RD AVE E PUYALLUP WA 983716227 | PUYALLUP | WA | 98371.0 | 131000.0 | 0.370057 | 354000.0 | 305000.0 | 403000.0 | 223000.0 | 0.0 | 0.0 | 1.423020 | 1.138420 | 1205.0 |
| 993 | 1405637 | 663093419 | 2020-02-12 | 2020-04-09 | 2020q1 | 53053 | 6302 90th Street Ct E | Puyallup | WA | 98371 | 71205 | 2 | Adam Williams | Wiktoria A Srebro | Evergreen Moneysource Mtg | Wiktoria A Srebro | 6302 90TH STREET CT E PUYALLUP WA 983716281 | PUYALLUP | WA | 98371.0 | 3450.0 | 0.009914 | 348000.0 | 307000.0 | 389000.0 | 313550.0 | 31000.0 | 0.0 | 1.350880 | 1.106320 | 1357.0 |
| 994 | 1405669 | 672923293 | 2020-07-21 | 2020-08-27 | 2020q3 | 53053 | 3415 E L St | Tacoma | WA | 98404 | 62000 | 1 | Peter F & Cherie L Suski | Brandon L Che | Amanda Castanon | On Q Fin'l | Brandon L Che | Amanda Castanon | 3415 E L ST TACOMA WA 984043924 | TACOMA | WA | 98404.0 | 161958.0 | 0.457508 | 354000.0 | 293000.0 | 415000.0 | 192042.0 | 0.0 | 0.0 | 1.401070 | 1.038140 | 1684.0 |
| 995 | 1405680 | 664031896 | 2020-03-02 | 2020-04-09 | 2020q1 | 53053 | 5212 S Pine St | Tacoma | WA | 98409 | 62900 | 2 | Woolery T & A L/TR | Patricia L Simanek | Bay Equity | Patricia L Simanek | 5212 S PINE ST TACOMA WA 984096345 | TACOMA | WA | 98409.0 | 163000.0 | 0.610487 | 267000.0 | 210000.0 | 323000.0 | 104000.0 | 0.0 | 0.0 | 1.413650 | 1.039330 | 1330.0 |
| 996 | 1405683 | 679185090 | 2020-09-23 | 2020-10-15 | 2020q3 | 53053 | 5602 S Oakes St | Tacoma | WA | 98409 | 63000 | 1 | Bill Streepy | Milton D & Patricia A Hardy | Veterans United Hm LNS | Milton D & Patricia A Hardy | 5602 S OAKES ST TACOMA WA 984096212 | TACOMA | WA | 98409.0 | 23224.0 | 0.067316 | 345000.0 | 277000.0 | 412000.0 | 321776.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 1532.0 |
| 997 | 1405684 | 663571722 | 2020-02-21 | 2020-04-09 | 2020q1 | 53053 | 5619 S Clement Ave | Tacoma | WA | 98409 | 62900 | 3 | Brandon A Andrews | Mitchell A Horn | Michelle L Konikow | American Pacific Mtg | Mitchell A Horn | Michelle L Konikow | 5619 S S CLEMENT AVE TACOMA WA 98409 | TACOMA | WA | 98409.0 | 152859.0 | 0.434259 | 352000.0 | 275000.0 | 428000.0 | 199141.0 | 0.0 | 0.0 | 1.110750 | 0.965909 | 1520.0 |
| 998 | 1405693 | 670140591 | 2020-06-12 | 2020-07-23 | 2020q2 | 53053 | 5636 S Cedar St | Tacoma | WA | 98409 | 62900 | 3 | Payton D Kemp | Brian & Erlinda A Tuskan | Bay Equity | Brian & Erlinda A Tuskan | 15024 126TH AVE NE WOODINVILLE WA 980724670 | WOODINVILLE | WA | 98072.0 | 27437.0 | 0.102377 | 268000.0 | 219000.0 | 318000.0 | 240563.0 | 0.0 | 0.0 | 1.478780 | 1.287310 | 1224.0 |
| 999 | 1405705 | 664337065 | 2020-03-03 | 2020-04-09 | 2020q1 | 53053 | 2210 178th St E | Tacoma | WA | 98445 | 71406 | 1 | T Van Tung | Kevin J Gonzales | Chiennsry K V Alcance | Guaranteed Rate | Kevin J Gonzales | Chiennsry K V Alcance | 2210 178TH ST E TACOMA WA 984454212 | TACOMA | WA | 98445.0 | 30000.0 | 0.088235 | 340000.0 | 309000.0 | 370000.0 | 176000.0 | 44000.0 | 90000.0 | 1.289530 | 1.079410 | 2076.0 |
| 1000 | 1405734 | 674051640 | 2020-08-03 | 2020-08-27 | 2020q3 | 53053 | 9828 Patterson St S | Tacoma | WA | 98444 | 71705 | 1 | Korrissa A Custard | Joseph C & Chelsea C Baldwin | Roy & Patricia Helland | Joseph C & Chelsea C Baldwin | 908 73RD ST E TACOMA WA 984045509 | TACOMA | WA | 98404.0 | 109600.0 | 0.397101 | 276000.0 | 217000.0 | 336000.0 | 166400.0 | 0.0 | 0.0 | 0.910302 | 0.742754 | 1064.0 |